﻿using System;

namespace edowork.com.Model
{
    #region check_stockInfo

    [Serializable]
    public class check_stockInfo
    {
        #region Private fields

        protected string _csid = String.Empty;
        protected string _billdate = String.Empty;
        protected string _billtype = String.Empty;
        protected string _remark = String.Empty;
        protected string _warehouseid = String.Empty;
        protected string _areaid = String.Empty;
        protected string _userid = String.Empty;
        protected string _sysdate = String.Empty;
        protected string _staffID = String.Empty;
        protected string _staffstu = String.Empty;
        protected string _staffremark = String.Empty;
        protected string _checkuserid = String.Empty;
        protected string _checkdate = String.Empty;
        protected string _checkstu = String.Empty;
        protected string _checkremark = String.Empty;
        protected string _m_stu = String.Empty;
        protected string _m_date = String.Empty;
        protected string _m_ID = String.Empty;

        #endregion

        public check_stockInfo() { }

        #region Public Properties

        public string Csid
        {
            get { return _csid; }
            set { _csid = value; }
        }

        public string Billdate
        {
            get { return _billdate; }
            set { _billdate = value; }
        }

        public string Billtype
        {
            get { return _billtype; }
            set { _billtype = value; }
        }

        public string Remark
        {
            get { return _remark; }
            set { _remark = value; }
        }

        public string Warehouseid
        {
            get { return _warehouseid; }
            set { _warehouseid = value; }
        }

        public string Areaid
        {
            get { return _areaid; }
            set { _areaid = value; }
        }

        public string Userid
        {
            get { return _userid; }
            set { _userid = value; }
        }

        public string Sysdate
        {
            get { return _sysdate; }
            set { _sysdate = value; }
        }

        public string StaffID
        {
            get { return _staffID; }
            set { _staffID = value; }
        }

        public string Staffstu
        {
            get { return _staffstu; }
            set { _staffstu = value; }
        }

        public string Staffremark
        {
            get { return _staffremark; }
            set { _staffremark = value; }
        }

        public string Checkuserid
        {
            get { return _checkuserid; }
            set { _checkuserid = value; }
        }

        public string Checkdate
        {
            get { return _checkdate; }
            set { _checkdate = value; }
        }

        public string Checkstu
        {
            get { return _checkstu; }
            set { _checkstu = value; }
        }

        public string Checkremark
        {
            get { return _checkremark; }
            set { _checkremark = value; }
        }

        public string M_stu
        {
            get { return _m_stu; }
            set { _m_stu = value; }
        }

        public string M_date
        {
            get { return _m_date; }
            set { _m_date = value; }
        }

        public string M_ID
        {
            get { return _m_ID; }
            set { _m_ID = value; }
        }

        #endregion

        #region Public SQL Script

        public string SQL_Insert()
        {
            return "insert into check_stock(Csid,Billdate,Billtype,Remark,Warehouseid,Areaid,Userid,Sysdate,StaffID,Staffstu,Staffremark,Checkuserid,Checkdate,Checkstu,Checkremark,M_stu,M_date,M_ID) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}')";
        }

        #endregion

    }

    #endregion
}

